modified NFL data report

Dataset statistics

Number of variables	11
Number of observations	6597
Missing cells	7194
Missing cells (%)	9.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	567.1 KiB
Average record size in memory	88.0 B

Variable types

NUM	8
CAT	2
BOOL	1

Warnings

`Forty` has 237 (3.6%) missing values	Missing
`Vertical` has 1350 (20.5%) missing values	Missing
`BenchReps` has 1984 (30.1%) missing values	Missing
`BroadJump` has 1403 (21.3%) missing values	Missing
`Shuttle` has 2220 (33.7%) missing values	Missing
`df_index` has unique values	Unique
`Player` has unique values	Unique

Reproduction

Analysis started	2021-01-11 03:41:35.336910
Analysis finished	2021-01-11 03:41:52.776200
Duration	17.44 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	6597
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3412.339851
Minimum	0
Maximum	6822
Zeros	1
Zeros (%)	< 0.1%
Memory size	51.5 KiB

Quantile statistics

Minimum	0
5-th percentile	341.8
Q1	1707
median	3411
Q3	5117
95-th percentile	6480.2
Maximum	6822
Range	6822
Interquartile range (IQR)	3410

Descriptive statistics

Standard deviation	1969.642706
Coefficient of variation (CV)	0.5772117642
Kurtosis	-1.1991789
Mean	3412.339851
Median Absolute Deviation (MAD)	1705
Skewness	-0.001188134182
Sum	22511206
Variance	3879492.388
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
3331	1	< 0.1%
1258	1	< 0.1%
3307	1	< 0.1%
5360	1	< 0.1%
1266	1	< 0.1%
3315	1	< 0.1%
5368	1	< 0.1%
1274	1	< 0.1%
3323	1	< 0.1%
Other values (6587)	6587	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
6822	1	< 0.1%
6820	1	< 0.1%
6819	1	< 0.1%
6818	1	< 0.1%
6817	1	< 0.1%

Player
Categorical

UNIQUE

Distinct	6597
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	51.5 KiB

Vinnie Sunseri	1
Ramon Foster	1
Jordan Mack	1
Nico Johnson	1
Steven Johnson	1
Other values (6592)	6592

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Vinnie Sunseri	1	< 0.1%
Ramon Foster	1	< 0.1%
Jordan Mack	1	< 0.1%
Nico Johnson	1	< 0.1%
Steven Johnson	1	< 0.1%
Russell Wilson	1	< 0.1%
Simmie Cobbs	1	< 0.1%
Ryan Tujague	1	< 0.1%
Josh Freeman	1	< 0.1%
Jake Matthews	1	< 0.1%
Other values (6587)	6587	99.8%

Frequencies of value counts

Unique

Unique	6597 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	27
Median length	13
Mean length	12.91450659
Min length	7

Pos
Categorical

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	51.5 KiB

DB	1240
OL	1093
DL	1068
WR	942
LB	777
Other values (5)	1477

Frequencies
Length

Value	Count	Frequency (%)
DB	1240	18.8%
OL	1093	16.6%
DL	1068	16.2%
WR	942	14.3%
LB	777	11.8%
RB	596	9.0%
QB	382	5.8%
TE	378	5.7%
FB	118	1.8%
NT	3	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Ht
Real number (ℝ_≥0)

Distinct	18
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	73.83810823
Minimum	65
Maximum	82
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	65
5-th percentile	69
Q1	72
median	74
Q3	76
95-th percentile	78
Maximum	82
Range	17
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.622993316
Coefficient of variation (CV)	0.03552357148
Kurtosis	-0.4644781152
Mean	73.83810823
Median Absolute Deviation (MAD)	2
Skewness	-0.1605866643
Sum	487110
Variance	6.880093934
Monotocity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
75	949	14.4%
74	859	13.0%
76	836	12.7%
73	799	12.1%
72	737	11.2%
77	609	9.2%
71	592	9.0%
70	406	6.2%
78	294	4.5%
69	231	3.5%
Other values (8)	285	4.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
65	1	< 0.1%
66	9	0.1%
67	33	0.5%
68	74	1.1%
69	231	3.5%

Value	Count	Frequency (%)
82	2	< 0.1%
81	4	0.1%
80	38	0.6%
79	124	1.9%
78	294	4.5%

Wt
Real number (ℝ_≥0)

Distinct	205
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	244.1881158
Minimum	149
Maximum	375
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	149
5-th percentile	186
Q1	206
median	235
Q3	283
95-th percentile	320
Maximum	375
Range	226
Interquartile range (IQR)	77

Descriptive statistics

Standard deviation	45.12082282
Coefficient of variation (CV)	0.1847789466
Kurtosis	-0.9579274421
Mean	244.1881158
Median Absolute Deviation (MAD)	32
Skewness	0.4840688377
Sum	1610909
Variance	2035.888652
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
211	86	1.3%
204	83	1.3%
205	82	1.2%
210	81	1.2%
195	80	1.2%
213	76	1.2%
199	76	1.2%
193	75	1.1%
209	75	1.1%
197	75	1.1%
Other values (195)	5808	88.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
149	1	< 0.1%
155	1	< 0.1%
156	1	< 0.1%
160	2	< 0.1%
163	1	< 0.1%

Value	Count	Frequency (%)
375	1	< 0.1%
370	1	< 0.1%
369	2	< 0.1%
366	1	< 0.1%
364	1	< 0.1%

Forty
Real number (ℝ_≥0)

MISSING

Distinct	159
Distinct (%)	2.5%
Missing	237
Missing (%)	3.6%
Infinite	0
Infinite (%)	0.0%

Mean	4.775927673
Minimum	4.22
Maximum	6.05
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	4.22
5-th percentile	4.4
Q1	4.54
median	4.69
Q3	4.97
95-th percentile	5.36
Maximum	6.05
Range	1.83
Interquartile range (IQR)	0.43

Descriptive statistics

Standard deviation	0.3054292303
Coefficient of variation (CV)	0.06395181235
Kurtosis	-0.1377582138
Mean	4.775927673
Median Absolute Deviation (MAD)	0.19
Skewness	0.8004250999
Sum	30374.9
Variance	0.09328701474
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.5	149	2.3%
4.56	136	2.1%
4.65	135	2.0%
4.62	130	2.0%
4.58	124	1.9%
4.52	122	1.8%
4.59	122	1.8%
4.53	121	1.8%
4.6	112	1.7%
4.51	107	1.6%
Other values (149)	5102	77.3%
(Missing)	237	3.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.22	2	< 0.1%
4.24	1	< 0.1%
4.26	1	< 0.1%
4.27	3	< 0.1%
4.28	5	0.1%

Value	Count	Frequency (%)
6.05	1	< 0.1%
6	1	< 0.1%
5.99	1	< 0.1%
5.86	1	< 0.1%
5.85	2	< 0.1%

Vertical
Real number (ℝ_≥0)

MISSING

Distinct	56
Distinct (%)	1.1%
Missing	1350
Missing (%)	20.5%
Infinite	0
Infinite (%)	0.0%

Mean	32.89041357
Minimum	17.5
Maximum	46
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	17.5
5-th percentile	25.5
Q1	30
median	33
Q3	36
95-th percentile	39.5
Maximum	46
Range	28.5
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.20369842
Coefficient of variation (CV)	0.1278092296
Kurtosis	-0.1693808794
Mean	32.89041357
Median Absolute Deviation (MAD)	3
Skewness	-0.2027207095
Sum	172576
Variance	17.6710804
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	274	4.2%
34	257	3.9%
33.5	255	3.9%
35.5	247	3.7%
35	239	3.6%
34.5	236	3.6%
36	233	3.5%
32.5	231	3.5%
32	220	3.3%
31	193	2.9%
Other values (46)	2862	43.4%
(Missing)	1350	20.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
17.5	1	< 0.1%
19	1	< 0.1%
19.5	3	< 0.1%
20	1	< 0.1%
20.5	7	0.1%

Value	Count	Frequency (%)
46	1	< 0.1%
45.5	1	< 0.1%
45	4	0.1%
44.5	2	< 0.1%
44	3	< 0.1%

BenchReps
Real number (ℝ_≥0)

MISSING

Distinct	45
Distinct (%)	1.0%
Missing	1984
Missing (%)	30.1%
Infinite	0
Infinite (%)	0.0%

Mean	20.84825493
Minimum	2
Maximum	49
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	2
5-th percentile	11
Q1	16
median	21
Q3	25
95-th percentile	32
Maximum	49
Range	47
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.357309962
Coefficient of variation (CV)	0.3049324743
Kurtosis	0.09351553067
Mean	20.84825493
Median Absolute Deviation (MAD)	4
Skewness	0.2618927776
Sum	96173
Variance	40.41538995
Monotocity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
19	287	4.4%
21	282	4.3%
23	276	4.2%
20	266	4.0%
24	265	4.0%
22	265	4.0%
17	256	3.9%
18	253	3.8%
15	243	3.7%
16	220	3.3%
Other values (35)	2000	30.3%
(Missing)	1984	30.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	2	< 0.1%
4	5	0.1%
5	5	0.1%
6	10	0.2%

Value	Count	Frequency (%)
49	1	< 0.1%
45	3	< 0.1%
44	4	0.1%
43	1	< 0.1%
42	4	0.1%

BroadJump
Real number (ℝ_≥0)

MISSING

Distinct	62
Distinct (%)	1.2%
Missing	1403
Missing (%)	21.3%
Infinite	0
Infinite (%)	0.0%

Mean	114.3313439
Minimum	74
Maximum	147
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	74
5-th percentile	97
Q1	109
median	115
Q3	121
95-th percentile	128
Maximum	147
Range	73
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	9.329193161
Coefficient of variation (CV)	0.08159786149
Kurtosis	-0.004707499552
Mean	114.3313439
Median Absolute Deviation (MAD)	6
Skewness	-0.4149984857
Sum	593837
Variance	87.03384503
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120	276	4.2%
118	252	3.8%
115	234	3.5%
117	233	3.5%
116	233	3.5%
121	232	3.5%
113	210	3.2%
119	209	3.2%
114	195	3.0%
112	191	2.9%
Other values (52)	2929	44.4%
(Missing)	1403	21.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
74	1	< 0.1%
78	1	< 0.1%
82	2	< 0.1%
84	1	< 0.1%
85	4	0.1%

Value	Count	Frequency (%)
147	1	< 0.1%
141	3	< 0.1%
140	1	< 0.1%
139	3	< 0.1%
138	3	< 0.1%

Shuttle
Real number (ℝ_≥0)

MISSING

Distinct	235
Distinct (%)	5.4%
Missing	2220
Missing (%)	33.7%
Infinite	0
Infinite (%)	0.0%

Mean	4.495179347
Minimum	3.73
Maximum	8.28
Zeros	0
Zeros (%)	0.0%
Memory size	51.5 KiB

Quantile statistics

Minimum	3.73
5-th percentile	4.03
Q1	4.2
median	4.36
Q3	4.59
95-th percentile	5.052
Maximum	8.28
Range	4.55
Interquartile range (IQR)	0.39

Descriptive statistics

Standard deviation	0.5942651132
Coefficient of variation (CV)	0.1322005347
Kurtosis	14.97982115
Mean	4.495179347
Median Absolute Deviation (MAD)	0.18
Skewness	3.638234266
Sum	19675.4
Variance	0.3531510247
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.4	105	1.6%
4.28	101	1.5%
4.21	94	1.4%
4.2	92	1.4%
4.15	84	1.3%
4.25	84	1.3%
4.18	82	1.2%
4.32	81	1.2%
4.07	77	1.2%
4.33	72	1.1%
Other values (225)	3505	53.1%
(Missing)	2220	33.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.73	1	< 0.1%
3.75	1	< 0.1%
3.78	1	< 0.1%
3.8	1	< 0.1%
3.81	2	< 0.1%

Value	Count	Frequency (%)
8.28	1	< 0.1%
8.15	1	< 0.1%
8.13	1	< 0.1%
8.06	1	< 0.1%
8.02	1	< 0.1%

pro bowl?
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.5 KiB

0	6046
1	551

Common Values
Chart

Value	Count	Frequency (%)
0	6046	91.6%
1	551	8.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	df_index	Player	Pos	Ht	Wt	Forty	Vertical	BenchReps	BroadJump	Shuttle	pro bowl?
0	0	John Abraham	LB	76	252	4.55	NaN	NaN	NaN	NaN	1
1	1	Shaun Alexander	RB	72	218	4.58	NaN	NaN	NaN	NaN	1
2	2	Darnell Alford	OL	76	334	5.56	25.0	23.0	94.0	4.98	0
3	3	Kyle Allamon	TE	74	253	4.97	29.0	NaN	104.0	4.49	0
4	4	Rashard Anderson	DB	74	206	4.55	34.0	NaN	123.0	4.15	0
5	6	LaVar Arrington	LB	75	250	4.53	NaN	NaN	NaN	NaN	1
6	7	Corey Atkins	LB	72	237	4.72	31.0	21.0	112.0	4.39	0
7	9	Reggie Austin	DB	69	175	4.44	35.0	17.0	119.0	4.14	0
8	11	Mark Baniewicz	OL	78	312	5.34	28.0	20.0	96.0	4.73	0
9	12	Rashidi Barnes	DB	72	208	4.62	35.0	10.0	114.0	4.32	0

Last rows

	df_index	Player	Pos	Ht	Wt	Forty	Vertical	BenchReps	BroadJump	Shuttle	pro bowl?
6587	6812	Logan Wilson	LB	74	241	4.63	32.0	21.0	121.0	4.27	0
6588	6813	Rob Windsor	DL	76	285	4.90	28.5	21.0	111.0	4.44	0
6589	6814	Antoine Winfield	DB	70	205	4.45	36.0	NaN	124.0	NaN	1
6590	6815	Tristan Wirfs	OL	77	322	4.85	36.5	24.0	121.0	4.68	0
6591	6816	Steven Wirtel	DB	76	227	4.76	26.0	NaN	120.0	4.28	0
6592	6817	Charlie Woerner	TE	77	245	4.78	34.5	21.0	120.0	4.46	0
6593	6818	D.J. Wonnum	DL	77	254	4.73	34.5	20.0	123.0	4.44	0
6594	6819	Dom Wood-Anderson	TE	76	257	4.92	35.0	NaN	119.0	NaN	0
6595	6820	David Woodward	LB	74	235	4.79	33.5	16.0	114.0	4.37	0
6596	6822	Jabari Zuniga	DL	75	253	4.64	33.0	29.0	127.0	NaN	0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows